/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50538
 Source Host           : localhost
 Source Database       : hdphp

 Target Server Type    : MySQL
 Target Server Version : 50538
 File Encoding         : utf-8

 Date: 11/20/2014 18:28:01 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `blog`
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` char(100) DEFAULT NULL COMMENT '标题',
  `cid` smallint(6) DEFAULT NULL,
  `click` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `blog`
-- ----------------------------
BEGIN;
INSERT INTO `blog` VALUES ('1', 'Route路由器学习', '2', '199'), ('2', 'hdphp视频周一到周五每天更新', '1', '199'), ('3', 'cache()方法学习后盾网', '2', '199'), ('4', 'www.houdunwang.com后盾网 人人做后盾', '1', '199'), ('5', '我爱后盾网', '2', '199'), ('6', '我们来学习INSERT方法', '1', '199'), ('7', '欢迎大家来后盾网参观', '2', '199'), ('8', '快学网即将上线。', '1', '199'), ('9', '这是使用属性映射的方式添加的', '3', '199'), ('12', '后盾网 唯一拥有自主产品PHP培训机构', '1', '12'), ('13', '最新HDPHP框架，即将发布houdunwang.com', '2', '2'), ('14', '后盾网', null, null), ('15', '后盾网PHP', '100', null), ('16', '后盾网PHP培训', null, '100');
COMMIT;

-- ----------------------------
--  Table structure for `blog2`
-- ----------------------------
DROP TABLE IF EXISTS `blog2`;
CREATE TABLE `blog2` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` char(100) DEFAULT NULL COMMENT '标题',
  `cid` smallint(6) DEFAULT NULL,
  `click` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `blog2`
-- ----------------------------
BEGIN;
INSERT INTO `blog2` VALUES ('1', 'hdphp', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `category`
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `cid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `catname` char(50) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `category`
-- ----------------------------
BEGIN;
INSERT INTO `category` VALUES ('1', '汽车资讯'), ('2', 'HDPHP框架使用');
COMMIT;

-- ----------------------------
--  Table structure for `category2`
-- ----------------------------
DROP TABLE IF EXISTS `category2`;
CREATE TABLE `category2` (
  `cid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `catname` char(50) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `category2`
-- ----------------------------
BEGIN;
INSERT INTO `category2` VALUES ('1', 'hdphp');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
